Download Oracle Business Intelligence Foundation Suite 11g Essentials.1z0-591.CertKiller.2019-01-19.72q.vcex

A: Combining Relational and OLAP Data Sources: Oracle’s Common Enterprise Information Model allows users to combine data from a relational system and an OLAP source in a single calculation. For example, a user can compare sales forecasts from an Oracle CRM System with budget data from an Oracle Essbase planning application. To clients of the Common Enterprise Information Model, the forecast and budget data appear to be from the same logical source. The Essbase server provides advanced multi-user read and write capabilities, including data update and multi-user recalculation. Business users with front-end tools can write data back to a server and recalculate the data on a server using calculation scripts—key functionality to support sophisticated modeling and planning applications. Using aggregate storage, Essbase serves a wide range of analytic needs—financial analysis, planning, budgeting, sales analysis, marketing analysis, supply-chain analysis, and profitability analytics—all from a single analytic infrastructure. B: Note: The Analytic Data Model (ADM) is an API used to access OLAP data and metadata. ADM is similar to JDBC, providing a single common API that hides most differences between OLAP data sources. Note 2: Data model for business intelligenceThe most important component of business intelligence is the concept of 'data model'. data model determinde what kind of analysis that end user could do with the data. It is also an independant concept that could span across different vendor 's product. Unlike data model of the transaction system, the typical analytic data model is often denormalized and store extra data for analytic query and better query performance while transaction data model use is often normalized and optimized for a few data read and write, which is implemented by jointing many tables. The most common used analytic data model in business intelligence is call the 'Star schema' data model. With the Oracle business intelligence system, We could define star schema and dimension data model in the 'logical layer' in the admin tools. The data model in OBIEE could span different data source in physical layer, which means OBIEE have the capability of building one logical data model which is actually connect to different database in the backend

Note 1: There are four types of variables that you can use:Session Repository Presentation Request Note 2: Session VariablesA session variable is a variable that is initialized at login time for each user. When a user begins a session, the Oracle BI Server creates a new instance of a session variable and initializes it. There are as many instances of a session variable as there are active sessions on the Oracle BI Server. Each instance of a session variable could be initialized to a different value. There are two types of session variables:System — A session variable that the Oracle BI Server and Oracle BI Presentation Services use for specific purposes. System session variables have reserved names that cannot be used for other kinds of variables (such as static or dynamic repository variables and non-system session variables). Non-system — A system variable that the administrator creates and names. For example, the administrator might create a SalesRegion non-system variable that initializes the name of a user's sales region. The administrator creates non-system session variables using the Oracle BI Administration Tool. Incorrect answers:A: ETL Load Date is a DAC Source System Parameter.C: OLAP DSN is a Repository variable.

Query environment can be managed by setting query limits (governors) in the Repository (RPD) for particular Application Roles. You should always set query limits for particular application roles rather than for individual users. Steps:1. Login to Repository using OBIEE Admin Tool 2. Navigate to Manage > Identity 3. Go to Application Role tab, choose the role and double click on it to open.     4. Click on Permissions tab     5. Set the Query Limits. You can limit queries by the number of rows received, by maximum run time, and by restricting to particular time periods. You can also allow or disallow direct database requests or the Populate privilege.    

CurrentMonth can be calculated by a sql statement. Note:REPOSITORY VARIABLE(DYNAMIC) Initialized when BI server is started Assigned value dynamically based on the result of a query Value is dependent of the sql provided in Initialization Block Create a dynamic variable and provide a Name and Default Initializer.Create a new initialization block by clicking on the New button in the above screen.     Provide Intialization Block variable Name     Click on “Edit Data Source” button and provide the sql to be used for the variable, e.g. select lower(sys_context('USERENV','SESSION_USER'))||        '@'||        lower(sys_context('USERENV','DB_NAME'))   from dual;

WLS Embedded LDAP Server *By default, OBIEE 11g users and groups are now held in the WLS LDAP Server (C) - More robust directory for storing user details - Recommended for >1000 users *  WLS Admin Server Console now used for creating and maintaining users (A) * BI Server “outsources” all authentication, authorization to FMW11g (not B) * BI Administration tool now used for subject area and row-level security, connection pool passwords only (D) • WLS LDAP Server can be “swapped out” for alternative directories (MS AD etc)

The “Edit Column Formula” dialog box has a second, very tiny tab called, “Bins.”  You can use this tab to have OBIEE build a CASE statement for you in a formula (you can also create a CASE statement yourself by using one of the functions that appears under “Expressions” if you want).  A CASE statement is a lot like an IF-THEN-ELSE statement, except that it’s a little easier to read when you have multiple options.  Basically, it puts values in different buckets that you define. Note:Figure:    Incorrect answers:C: The “Conditional Format” tab lets you set formatting when specific conditions are met.

B: BI Server Security Manager accessed through the BI Server Administration Tool.Set permission to business model, tables, columns and subject areas Specify filters to limit data accessible by users Set authentication options C: Enable the SSO through the FMW Control.    D: You have three methods to start the managed server:with the console (recommended) with FMW control with the command line.

A: OBIEE 11g is centred on WebLogic Server as the underlying application server architecture.B: If you want to scale out this infrastructure, you would typically run the OBIEE 11g installer on a second server, and instead of choosing to do a new install, you’d choose to instead scale out the existing BI domain.     C: OBIEE Clustering – Approach of Oracle BI Server Load balancing/Failover

C: Oracle Business Intelligence authenticates users and get groups using an Oracle WebLogic Server authentication provider against user information held in an identity store. Incorrect answers:A: On 10g, Instanceconfig.xml is THE parameter file of the BI Presentation server. With the advent of 11g, instanceconfig.xml is also the configuration file of Oracle BI Scheduler The instanceconfig.xml file stores the configuration settings that affect Oracle BI Presentation Services. B: If you want to install the OBIEE Server you have to create some schemas in the database which will keep the OBIEE repository. For working, OBIEE needs some schemas to be created. This work is dome automatically by using rcu  (Repository Creation Utility).    In order to create the OBIEE schemas with the RCU, you must have installed an Oracle database (11g). D: NQSConfig.ini is the main configuration file of Bi Server and contains a lot of parameters.The file is located in this directory :11g: ORACLE_INSTANCE/config/OracleBIServerComponent/coreapplication_obisnAll changes made to this file require that you restart the Oracle BI Server Service. Note: OBIEE 10G/11G - The (Web|Presentation) Catalog (Webcat)The Web Catalog becomes in 11g the Presentation Catalog. publisher objects (such as reports and templates). Each object is composed of two files:its own file. For example, an analysis called Analysis 1 would be stored in a file named Analysis1. a attributes file. For example, the analysis called Analysis1 would have a corresponding attributes file named Analysis1.atr. The attributes file contains:the object's full name, access control list (ACL), description, and so on. To access an object in the catalog, users must have appropriate ACL entries for that object. All objects in the catalog use ACL entries. In 11g, the Everyone group has been replaced with the AuthenticatedUser role The webcatalog is located:on 11G: ORACLE_INSTANCE/bifoundation/OracleBIPresentationServicesComponent/catalog/

You do not use ODBC DSN to compare repositories. Note: When an ODBC based application connects to a database, it connects to a logical name, the Data Source Name (DSN), which identifies the datasource to which it wants to connect. Some external repository of configuration information holds the various DSN values that are available, together with the necessary configuration and control information needed by the ODBC driver to establish a connection and manage usage of the data source. The DSN (data source name) is a data structure that contains the information about a specific data source (database, …), typically used by an ODBC driver to be able to connect to it. The DSN contains information about the data source such as:the name, the directory, and the driver. On Windows, the DSN also specifies the ODBC driver to be used to access the database.